Views [dbo].[vSoaChangeLog]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:38:39 PM Friday, January 07, 2011
Last Modified1:49:25 PM Thursday, September 22, 2011
Columns
Name
ChangeLogId
IdentityEntityTypeName
IdentityIdentityElement
ChangeDate
Subtype
ChangedByUserId
LogText
SQL Script
CREATE VIEW [vSoaChangeLog]
AS
SELECT 'Party-' + [ID] +'-' + CONVERT(varchar, [DATE_TIME], 126) AS [ChangeLogId],
       'Party' AS [IdentityEntityTypeName],
       [ID] AS [IdentityIdentityElement],
       [DATE_TIME] AS [ChangeDate],
       [SUB_TYPE] AS [Subtype],
       [USER_ID] AS [ChangedByUserId],
       [LOG_TEXT] AS [LogText]
  FROM [Name_Log]


GO
Uses